CSU 15-min Data Check Report — generated 2026-08-18T15:32:32
Folder: data/CSU utility bills/CSU 15-min data

Records after merge/dedup: 6048
Date range: 2026-06-08 00:15:00 to 2026-08-10 00:00:00

Interval step distribution (minutes: count):
    15.0: 6047

No gaps found — full 15-min cadence maintained.

Zero-reading runs remaining after merge: 1
  2026-07-08 23:00:00 -> 2026-07-09 00:15:00

No negative consumption values found.

Duplicate-timestamp conflicts resolved during merge: 36
  2026-07-09 00:15:00: existing=0.0 (Usage_0702-0709.csv) vs new=8.49 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 00:30:00: existing=0.0 (Usage_0702-0709.csv) vs new=8.43 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 00:45:00: existing=0.0 (Usage_0702-0709.csv) vs new=8.91 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 01:00:00: existing=0.0 (Usage_0702-0709.csv) vs new=8.45 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 01:15:00: existing=0.0 (Usage_0702-0709.csv) vs new=7.92 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 01:30:00: existing=0.0 (Usage_0702-0709.csv) vs new=8.91 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 01:45:00: existing=0.0 (Usage_0702-0709.csv) vs new=7.85 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 02:00:00: existing=0.0 (Usage_0702-0709.csv) vs new=8.34 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 02:15:00: existing=0.0 (Usage_0702-0709.csv) vs new=9.36 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 02:30:00: existing=0.0 (Usage_0702-0709.csv) vs new=7.44 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 02:45:00: existing=0.0 (Usage_0702-0709.csv) vs new=7.24 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 03:00:00: existing=0.0 (Usage_0702-0709.csv) vs new=6.98 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 03:15:00: existing=0.0 (Usage_0702-0709.csv) vs new=6.32 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 03:30:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.1 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 03:45:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.18 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 04:00:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.32 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 04:15:00: existing=0.0 (Usage_0702-0709.csv) vs new=4.77 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 04:30:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.28 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 04:45:00: existing=0.0 (Usage_0702-0709.csv) vs new=4.8 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 05:00:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.13 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 05:15:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.44 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 05:30:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.1 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 05:45:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.04 (Usage_0709-0714.csv) -> replaced_zero
  2026-07-09 06:00:00: existing=0.0 (Usage_0702-0709.csv) vs new=5.75 (Usage_0709-0714.csv) -> replaced_zero
  2026-06-20 22:45:00: existing=3.52 (Usage_0614-0620.csv) vs new=9.54 (Usage_0620 10p-12a.csv) -> patch_override
  2026-06-20 23:00:00: existing=0.0 (Usage_0614-0620.csv) vs new=9.11 (Usage_0620 10p-12a.csv) -> patch_override
  2026-06-20 23:15:00: existing=0.0 (Usage_0614-0620.csv) vs new=9.42 (Usage_0620 10p-12a.csv) -> patch_override
  2026-06-20 23:30:00: existing=0.0 (Usage_0614-0620.csv) vs new=9.03 (Usage_0620 10p-12a.csv) -> patch_override
  2026-06-20 23:45:00: existing=0.0 (Usage_0614-0620.csv) vs new=9.11 (Usage_0620 10p-12a.csv) -> patch_override
  2026-06-21 00:00:00: existing=0.0 (Usage_0614-0620.csv) vs new=8.62 (Usage_0620 10p-12a.csv) -> patch_override
  2026-06-27 22:45:00: existing=2.24 (Usage_0621-0627.csv) vs new=6.79 (Usage_0627 10p-12a.csv) -> patch_override
  2026-06-27 23:00:00: existing=0.0 (Usage_0621-0627.csv) vs new=5.31 (Usage_0627 10p-12a.csv) -> patch_override
  2026-06-27 23:15:00: existing=0.0 (Usage_0621-0627.csv) vs new=5.51 (Usage_0627 10p-12a.csv) -> patch_override
  2026-06-27 23:30:00: existing=0.0 (Usage_0621-0627.csv) vs new=5.86 (Usage_0627 10p-12a.csv) -> patch_override
  2026-06-27 23:45:00: existing=0.0 (Usage_0621-0627.csv) vs new=5.57 (Usage_0627 10p-12a.csv) -> patch_override
  2026-06-28 00:00:00: existing=0.0 (Usage_0621-0627.csv) vs new=5.4 (Usage_0627 10p-12a.csv) -> patch_override

--- EDA summary ---
Total consumption: 40846.78 kWh
Average demand: 27.02 kW
Peak 15-min demand: 50.28 kW at 2026-06-08 18:15:00 (12.57 kWh interval)
Load factor (avg/peak): 53.73%
Total kVARh: 2346.92
Estimated overall power factor: 0.998

Daily totals (kWh):
  2026-06-08: 802.01
  2026-06-09: 698.19
  2026-06-10: 658.31
  2026-06-11: 708.04
  2026-06-12: 668.09
  2026-06-13: 594.35
  2026-06-14: 635.00
  2026-06-15: 610.27
  2026-06-16: 648.22
  2026-06-17: 674.05
  2026-06-18: 665.06
  2026-06-19: 667.09
  2026-06-20: 635.05
  2026-06-21: 647.12
  2026-06-22: 670.23
  2026-06-23: 621.76
  2026-06-24: 628.07
  2026-06-25: 561.99
  2026-06-26: 633.50
  2026-06-27: 672.17
  2026-06-28: 646.17
  2026-06-29: 696.14
  2026-06-30: 661.83
  2026-07-01: 629.92
  2026-07-02: 738.61
  2026-07-03: 575.45
  2026-07-04: 616.56
  2026-07-05: 624.85
  2026-07-06: 690.59
  2026-07-07: 616.37
  2026-07-08: 689.52
  2026-07-09: 701.70
  2026-07-10: 667.66
  2026-07-11: 710.53
  2026-07-12: 620.58
  2026-07-13: 577.31
  2026-07-14: 549.39
  2026-07-15: 566.82
  2026-07-16: 629.26
  2026-07-17: 665.20
  2026-07-18: 680.41
  2026-07-19: 641.63
  2026-07-20: 659.55
  2026-07-21: 627.42
  2026-07-22: 652.29
  2026-07-23: 610.25
  2026-07-24: 624.18
  2026-07-25: 679.24
  2026-07-26: 742.53
  2026-07-27: 703.74
  2026-07-28: 657.90
  2026-07-29: 629.85
  2026-07-30: 582.83
  2026-07-31: 618.77
  2026-08-01: 640.47
  2026-08-02: 644.66
  2026-08-03: 604.75
  2026-08-04: 560.76
  2026-08-05: 580.96
  2026-08-06: 620.41
  2026-08-07: 646.23
  2026-08-08: 764.73
  2026-08-09: 691.54
  2026-08-10: 8.65